﻿CREATE TABLE [dbo].[TransformationSetting]
(
	[TransformationSettingId] BIGINT NOT NULL PRIMARY KEY IDENTITY, 
	[ProjectId] INT NOT NULL,
    [QueryId] INT, 
    [TransformationBreakdownId] SMALLINT NOT NULL, 
    [Value] VARCHAR(50) NOT NULL, 
    CONSTRAINT [FK_TransformationSetting_Query] FOREIGN KEY ([QueryId]) REFERENCES [dbo].[Query]([QueryId]), 
    CONSTRAINT [FK_TransformationSetting_TransformationBreakdown] FOREIGN KEY ([TransformationBreakdownId]) REFERENCES [dbo].[TransformationBreakdown]([TransformationBreakdownId]), 
    CONSTRAINT [FK_TransformationSetting_Project] FOREIGN KEY ([ProjectId]) REFERENCES [dbo].[Project]([ProjectId])
)
